Application of the Microsoft Excel Solver tool in the solution of optimization problems of heat exchanger network systems

Optimization of heat exchanger networks (HEN_S) is a field of interest in Chemical Engineering. The aim is to use the residual heat of process streams to raise the temperature of other process streams which are cold, thus minimizing the use of hot and cold utilities. The usual way to deal with this task is to pose a linear programming problem according to a transshipment model in order to minimize either the general services consumptions or the number of hot and cold stream matchings required. This optimization is subjected to several restrictions given by the energy balances corresponding to each heat exchange.The high number of variables and equations obliges the use of specific software to solve these problems, e.g. GAMS (General Algebraic Modelling System). However, this software is not intuitive and requires a long time of training and a certain level of practice for the students to adequately use it.This work describes the use of Microsoft Excel-Solver for the sequential solving of HEN_S optimization problems according to the transshipment model. Solver is a much simpler, intuitive and easily available tool for the students who, besides, usually learn how to use it in the first years of their degree, in Informatics or similar subjects. Thus, it is not necessary to spend extra time in the teaching of the software, time that may be devoted to other contents.This paper presents an example of HEN_S problem proposed in the subject Simulation and Optimization of Chemical Processes corresponding to the Joint Master in Chemical Engineering of the Rey Juan Carlos University and the Autónoma University of Madrid and solved by the students using Excel-Solver.     

某尾矿库调洪计算

调洪计算在尾矿库设计和运行管理中都是非常重要的，水量平衡是常用计算方法，涉及较多的插值计算与试算。为了提高计算效率和计算质量，在利用Excel强大数据处理功能的同时，采用VBA编程方法实现计算过程自动化。降低了人工插值和试算对计算结果的影响，提高了工作效率。计算过程清晰，通用性强。     

Excel在管道安装计算中的应用

在工业管道安装中,采用传统的几何作图法或计算公式法对管件或管线连接放样计算效率低,容易出错,利用Excel软件的函数计算功能编程计算,快捷准确,方便高效。     

利用VB编程控制Excel处理测量数据

介绍了利用VB 6.0编程控制电子表格Excel处理测量数据的编程方法与技巧,从而实现测量数据处理可视化和制表自动化,提高了测量数据处理的效率和准确性.     

多层次模糊综合评定在测绘质量管理中的运用

阐述了用模糊数学的计算方法来评定测绘产品的质量优良等级的方法,并进一步结合Excel的计算功能,实现产品质量评定的科学化.     

Excel在岩土工程计算中的应用

以滑坡剩余推力法计算和地基沉降量计算为例,介绍了Excel在岩土工程计算中的一些应用,实践结果表明:Excel软件有其独特的优点,利用其进行岩土计算可以大大提高工作效率,值得推广应用。     

用有限差分法计算Winkle梁的一种方法

介绍了一种用有限差分法计算winkle弹性基础梁的简单实用的方法，此方法中Excel软件、Matlab软件联合使用，优势互补，组成一个开放的、易修改的、具有软件性质的计算模块。     

Excel在制冷机组故障检测与诊断工具开发中的应用

用Excel表格作为后台数据库,在VC平台上结合.NET数据库技术,开发了大型制冷机组的故障检测与诊断工具。用现场实验数据进行检验表明,该故障检测与诊断工具具有运行稳健,故障检测准确、快速等优点,能够用于生产现场的实时故障检测与诊断。     

测绘仪器精度状况管理方法探讨

测绘仪器精度状况管理是一项繁杂的、经常性的工作，Excel具有数据库的最基本的功能，利用Excel进行测绘仪器精度状况管理可以极大地提高效率，而且非常经济。本文以常规大地测量仪器为例子提出了其具体办法。     

用VB实现水准测量记录簿的自动生成

通过VB编程对EXCEL表格的控制来实现水准测量记录簿的自动生成。